If different Buy and Sell Currencies are used in this screen, it must be understood that there is no relationship between the exchange rates between the two currencies at Service Option rate level. In other words, there are two values – a buy value and a sell value which happen to have different currency labels on them and at the quoting/booking stage Tourplan’s exchange rate mechanism works out the necessary values based on what currency the quote or booking is being output in. To make the process of setting up multi-currency rates, an exchange rate field is provided below the Sell Currency dropdown (only visible when multiple currencies are used) which can be used to base the currency conversion on. This editable field also displays under the Rates tab. This exchange rate is not used in the bookings process – the exchange rate(s) from the Tourplan currencies table are used at that time. The Database currency rates can be updated in bulk using the Rate Maintenance applications. Examples of the different currencies screen is shown here.

The currencies must have already been defined in the Tourplan Code Maint module.

The Exchange Rate calculator field will default to a rate of 1.0000000, regardless of the currency pairs selected. The rate to use between the currencies must be manually entered. Rates can be on either a Multiply or Divide basis depending on the Radio button selected.

This screen becomes much larger in order to accommodate the extra columns required. Only the rate detail is displayed in Screen Shot 96: Date Ranges Rates Screen - Different Buy/Sell Currencies above.

When the exchange rate alters and the exchange rate/markup factor changes, the Rate Maintenance screen’s Modify Rates can be used to update the rates.

If the example shown was in the Product Database of a user company in the USA and bookings were being output in USD, then Tourplan would use its exchange rate mechanism to calculate the buy price in USD. The sell price would not be touched, since it is already in USD.

If the same example was in the Product Database of a user company in NZ, then the Output Currency of the Quote/Booking would determine what exchange rate mechanisms were used. If the Output Currency of the quote/booking was in USD, then the totals would be in USD, but internally, Tourplan would be calculating the Sell price on all services in NZD (so accurate margins could be reported). If the Output Currency of the quote/booking is in NZD, then all services and totals would be converted to NZD